SELECT Id FROM new_searchtable
where
(town = 'Cornish' and state='NH'
or town = 'Eastman' and state='NH'
or town = 'Enfield' and state='NH'
or town = 'Hanover' and state='NH'
or town = 'Lebanon' and state='NH'
or town = 'Lyme' and state='NH'
or town = 'Plainfield' and state='NH'
)
and (type = 'R' or type ='O')
and (bedrooms >='4') and (bedrooms >='4')
AND list_price BETWEEN '0' AND '30000000'
ORDER BY list_price Desc
Upper Valley Area NH Homes page 35
Granite Northland Associates
Serving Mascoma Lake Area
Call 603-523-7200
Description:2 HILTON FIELD LANE- Uniquely positioned at the end of Occom Pond with views over the former Hanover Country Club and partial views of the water, Hilton Field Lane presents a rare and extraordinary opportunity to own in the highly coveted Rope Ferry neighborhood of downtown Hanover. The mostly level .7-acre parcel features a lovely mix of landscaping and statuesque mature trees as well as a swimming pool and cabana on the east side of the property. The original 1910 colonial home–officially listed as a 6-bedroom/7-bath–offers stately living and dining areas and gorgeous original details while the entire structure has been well-upgraded and expanded over the years. There is an ADU (accessory dwelling unit) on the lower level as well as rented living space on the east side with a well-established rental history. Reimagine the historic home in your own design or develop a new vision for this incredible lot and location all while enjoying a short walk to Hanover’s shopping and restaurants, Dartmouth campus, and miles of conserved land in Pine Park across the street. Architectural floor plans available.
Description:Welcome to 10 Morgan Road—an expansive brick Colonial perched atop a stunning open meadow with western views across rolling fields to the Green Mountains of Vermont. Spread across 23.5 acres in Hanover's coveted Etna neighborhood, this property is just minutes to downtown Hanover, Dartmouth College, and Dartmouth Hitchcock Medical Center, yet wrapped in privacy virtually impossible to find in the Upper Valley. Built in 1991 and beautifully renovated in 2005, this home offers over 7,000 square feet of above-grade living space across three levels, plus a 3,300-square-foot finished lower level. Its generous size and practical four-level design maximize flexibility, accommodating year-round family living, extensive work-at-home options, inside and outside entertainment, and extended guest visits like no other Hanover property. A dramatic two-story foyer with an elegant double staircase sets the tone. Formal living and dining rooms flow into a spacious kitchen with a sun-filled breakfast area and a family room anchored by a fireplace. The west-facing sunroom is a showstopper—panoramic views, glorious sunsets, and natural light throughout the day. The spacious primary suite features a private office, a double-sided fireplace, a walk-in closet, and a stunning bath. Three additional bedrooms complete the second level. The third floor offers a private guest suite with a sitting room, two additional rooms, a full bath, and cedar closets. The finished lower level—bright and expansive with walkout access—houses a gym, media room, game rooms, craft space, and full bath. An attached three-car garage adds convenience. Outside, open hayfields, mature evergreens, and classic New England stone walls frame a setting of rare beauty. A truly rare opportunity—grand scale, an unrivaled setting, and outstanding proximity to everything the Dartmouth region offers.
Description:Gorgeous house to be built in rural Hanover on a 5.3+/- acre parcel with year round westerly mountain views. With high ceilings and huge imported European triple pane windows and sliding glass doors, the light in this house will be amazing. High end Wolf and SubZero appliances, gourmet kitchen with waterfall soapstone counter and large pantry. First floor master suite with very large marble bathroom and walk in closet. On the lower level, 3 additional bedrooms and bathrooms, each with its own slider to the outdoors. The quality of construction will be absolutely top-notch: this builder is exceptional! Previously built Hanover home will be possible to view.